CREATE TABLE [dbo].[DeferredIncomeWork]
(
[DeferredIncomeWorkKey] [uniqueidentifier] NOT NULL CONSTRAINT [DF_DeferredIncomeWork_DeferredIncomeWorkKey] DEFAULT (newid()),
[InvoiceKey] [uniqueidentifier] NULL,
[InvoiceNumber] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[EffectiveDate] [datetime] NULL,
[FinancialEntityCode] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[DeferredIncomeGLAccountCode] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[TargetGLAccountCode] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[AmountDeferred] [decimal] (18, 4) NOT NULL,
[DeferralTermsCode] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[OrganizationKey] [uniqueidentifier] NULL,
[GLTransactionLineKey] [uniqueidentifier] NULL,
[TotalAmountToBeDeferred] [decimal] (18, 4) NOT NULL,
[InvoiceLineKey] [uniqueidentifier] NULL,
[InvoiceLineNumber] [int] NULL,
[DeferralTermsKey] [uniqueidentifier] NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[DeferredIncomeWork] ADD CONSTRAINT [PK_DeferredIncomeWork] PRIMARY KEY CLUSTERED ([DeferredIncomeWorkKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_DeferredIncomeWork_OrganizationKey] ON [dbo].[DeferredIncomeWork] ([OrganizationKey]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[DeferredIncomeWork] ADD CONSTRAINT [FK_DeferredIncomeWork_OrganizationMain] FOREIGN KEY ([OrganizationKey]) REFERENCES [dbo].[OrganizationMain] ([OrganizationKey])
GO